home *** CD-ROM | disk | FTP | other *** search

---

/ Developer Source 14 / Developer Source Volume 14 (I-MODE Publications, Inc.)(1999).iso / delpp / fig18-09.gif

< prev

next >

Graphics Interchange Format  |  1996-11-19  |  11KB  |  593x454  |  4-bit (10 colors)

Labels: text | electronics | screenshot | display | software | computer | number
OCR: A [ab] OK x Form1.Query1 x SQL Demo Calculate total dollar value of Orders per Customer Run Custno TotalOrderValue SQL: Select Custno, SUM(ItemsTotal) 1221 $51,450.80 as TotalOrderValue From Orders 1231 $85,643.60 Group By Custno 1351 $261,575.80 1354 $59,660.05 1356 $69,364.70 1380 $48,599.50 1384 $193,079.75 1510 $56,674.05 1513 $90,143.40 Title (SQL(1) SQL(2) SQL(3) SQL(4) SQL(5) SQL(6)} SQL(7) SQL(8) SQL(9) SQL(10) SQL(11) SQL(12)

---